package com.ztesoft.web.common.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class DmIndexInfoArg {
    private String pk_name = "INDEX_INFO_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<DmIndexInfoCriteria> oredCriteria;

    public DmIndexInfoArg() {
        oredCriteria = new ArrayList<DmIndexInfoCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<DmIndexInfoCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(DmIndexInfoCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public DmIndexInfoCriteria or() {
    	DmIndexInfoCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DmIndexInfoCriteria createCriteria() {
    	DmIndexInfoCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected DmIndexInfoCriteria createCriteriaInternal() {
    	DmIndexInfoCriteria criteria = new DmIndexInfoCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<DmIndexInfoCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<DmIndexInfoCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<DmIndexInfoCriterion> getAllCriteria() {
            return criteria;
        }

        public List<DmIndexInfoCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new DmIndexInfoCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmIndexInfoCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmIndexInfoCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new DmIndexInfoCriterion(condition, value1, value2));
        }

        public DmIndexInfoCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (DmIndexInfoCriteria) this;
        }
        public DmIndexInfoCriteria andIndexInfoIdIsNull() {
            addCriterion("INDEX_INFO_ID is null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdIsNotNull() {
            addCriterion("INDEX_INFO_ID is not null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdEqualTo(Integer value) {
            addCriterion("INDEX_INFO_ID =", value, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdNotEqualTo(Integer value) {
            addCriterion("INDEX_INFO_ID <>", value, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdGreaterThan(Integer value) {
            addCriterion("INDEX_INFO_ID >", value, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("INDEX_INFO_ID >=", value, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdLessThan(Integer value) {
            addCriterion("INDEX_INFO_ID <", value, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdLessThanOrEqualTo(Integer value) {
            addCriterion("INDEX_INFO_ID <=", value, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdLike(Integer value) {
            addCriterion("INDEX_INFO_ID like ", value, "INDEX_INFO_ID", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdNotLike(Integer value) {
            addCriterion("INDEX_INFO_ID  not like ", value, "INDEX_INFO_ID", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdLeftLike(Integer value) {
            addCriterion("INDEX_INFO_ID like ", value, "INDEX_INFO_ID", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdNotLeftLike(Integer value) {
            addCriterion("INDEX_INFO_ID  not like ", value, "INDEX_INFO_ID", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdRightLike(Integer value) {
            addCriterion("INDEX_INFO_ID like ", value, "INDEX_INFO_ID", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdNotRightLike(Integer value) {
            addCriterion("INDEX_INFO_ID  not like ", value, "INDEX_INFO_ID", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdIn(List<Integer> values) {
            addCriterion("INDEX_INFO_ID  in ", values, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdNotIn(List<Integer> values) {
            addCriterion("INDEX_INFO_ID not in ", values, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdBetween(Integer value1, Integer value2) {
            addCriterion("INDEX_INFO_ID between ", value1, value2, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexInfoIdNotBetween(Integer value1, Integer value2) {
            addCriterion("INDEX_INFO_ID not between ", value1, value2, "INDEX_INFO_ID");
            return (DmIndexInfoCriteria) this;
        }
        public DmIndexInfoCriteria andDataIdIsNull() {
            addCriterion("DATA_ID is null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdIsNotNull() {
            addCriterion("DATA_ID is not null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdEqualTo(Integer value) {
            addCriterion("DATA_ID =", value, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdNotEqualTo(Integer value) {
            addCriterion("DATA_ID <>", value, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdGreaterThan(Integer value) {
            addCriterion("DATA_ID >", value, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DATA_ID >=", value, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdLessThan(Integer value) {
            addCriterion("DATA_ID <", value, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdLessThanOrEqualTo(Integer value) {
            addCriterion("DATA_ID <=", value, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdLike(Integer value) {
            addCriterion("DATA_ID like ", value, "DATA_ID", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdNotLike(Integer value) {
            addCriterion("DATA_ID  not like ", value, "DATA_ID", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdLeftLike(Integer value) {
            addCriterion("DATA_ID like ", value, "DATA_ID", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdNotLeftLike(Integer value) {
            addCriterion("DATA_ID  not like ", value, "DATA_ID", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdRightLike(Integer value) {
            addCriterion("DATA_ID like ", value, "DATA_ID", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdNotRightLike(Integer value) {
            addCriterion("DATA_ID  not like ", value, "DATA_ID", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdIn(List<Integer> values) {
            addCriterion("DATA_ID  in ", values, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdNotIn(List<Integer> values) {
            addCriterion("DATA_ID not in ", values, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdBetween(Integer value1, Integer value2) {
            addCriterion("DATA_ID between ", value1, value2, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andDataIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DATA_ID not between ", value1, value2, "DATA_ID");
            return (DmIndexInfoCriteria) this;
        }
        public DmIndexInfoCriteria andTableNameIsNull() {
            addCriterion("TABLE_NAME is null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameIsNotNull() {
            addCriterion("TABLE_NAME is not null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameEqualTo(String value) {
            addCriterion("TABLE_NAME =", value, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameNotEqualTo(String value) {
            addCriterion("TABLE_NAME <>", value, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameGreaterThan(String value) {
            addCriterion("TABLE_NAME >", value, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameGreaterThanOrEqualTo(String value) {
            addCriterion("TABLE_NAME >=", value, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameLessThan(String value) {
            addCriterion("TABLE_NAME <", value, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameLessThanOrEqualTo(String value) {
            addCriterion("TABLE_NAME <=", value, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameLike(String value) {
            addCriterion("TABLE_NAME like ", value, "TABLE_NAME", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameNotLike(String value) {
            addCriterion("TABLE_NAME  not like ", value, "TABLE_NAME", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameLeftLike(String value) {
            addCriterion("TABLE_NAME like ", value, "TABLE_NAME", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameNotLeftLike(String value) {
            addCriterion("TABLE_NAME  not like ", value, "TABLE_NAME", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameRightLike(String value) {
            addCriterion("TABLE_NAME like ", value, "TABLE_NAME", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameNotRightLike(String value) {
            addCriterion("TABLE_NAME  not like ", value, "TABLE_NAME", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameIn(List<String> values) {
            addCriterion("TABLE_NAME  in ", values, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameNotIn(List<String> values) {
            addCriterion("TABLE_NAME not in ", values, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameBetween(String value1, String value2) {
            addCriterion("TABLE_NAME between ", value1, value2, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andTableNameNotBetween(String value1, String value2) {
            addCriterion("TABLE_NAME not between ", value1, value2, "TABLE_NAME");
            return (DmIndexInfoCriteria) this;
        }
        public DmIndexInfoCriteria andIndexNameIsNull() {
            addCriterion("INDEX_NAME is null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameIsNotNull() {
            addCriterion("INDEX_NAME is not null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameEqualTo(String value) {
            addCriterion("INDEX_NAME =", value, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameNotEqualTo(String value) {
            addCriterion("INDEX_NAME <>", value, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameGreaterThan(String value) {
            addCriterion("INDEX_NAME >", value, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameGreaterThanOrEqualTo(String value) {
            addCriterion("INDEX_NAME >=", value, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameLessThan(String value) {
            addCriterion("INDEX_NAME <", value, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameLessThanOrEqualTo(String value) {
            addCriterion("INDEX_NAME <=", value, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameLike(String value) {
            addCriterion("INDEX_NAME like ", value, "INDEX_NAME", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameNotLike(String value) {
            addCriterion("INDEX_NAME  not like ", value, "INDEX_NAME", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameLeftLike(String value) {
            addCriterion("INDEX_NAME like ", value, "INDEX_NAME", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameNotLeftLike(String value) {
            addCriterion("INDEX_NAME  not like ", value, "INDEX_NAME", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameRightLike(String value) {
            addCriterion("INDEX_NAME like ", value, "INDEX_NAME", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameNotRightLike(String value) {
            addCriterion("INDEX_NAME  not like ", value, "INDEX_NAME", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameIn(List<String> values) {
            addCriterion("INDEX_NAME  in ", values, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameNotIn(List<String> values) {
            addCriterion("INDEX_NAME not in ", values, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameBetween(String value1, String value2) {
            addCriterion("INDEX_NAME between ", value1, value2, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexNameNotBetween(String value1, String value2) {
            addCriterion("INDEX_NAME not between ", value1, value2, "INDEX_NAME");
            return (DmIndexInfoCriteria) this;
        }
        public DmIndexInfoCriteria andIndexColumnIsNull() {
            addCriterion("INDEX_COLUMN is null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnIsNotNull() {
            addCriterion("INDEX_COLUMN is not null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnEqualTo(String value) {
            addCriterion("INDEX_COLUMN =", value, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnNotEqualTo(String value) {
            addCriterion("INDEX_COLUMN <>", value, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnGreaterThan(String value) {
            addCriterion("INDEX_COLUMN >", value, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnGreaterThanOrEqualTo(String value) {
            addCriterion("INDEX_COLUMN >=", value, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnLessThan(String value) {
            addCriterion("INDEX_COLUMN <", value, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnLessThanOrEqualTo(String value) {
            addCriterion("INDEX_COLUMN <=", value, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnLike(String value) {
            addCriterion("INDEX_COLUMN like ", value, "INDEX_COLUMN", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnNotLike(String value) {
            addCriterion("INDEX_COLUMN  not like ", value, "INDEX_COLUMN", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnLeftLike(String value) {
            addCriterion("INDEX_COLUMN like ", value, "INDEX_COLUMN", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnNotLeftLike(String value) {
            addCriterion("INDEX_COLUMN  not like ", value, "INDEX_COLUMN", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnRightLike(String value) {
            addCriterion("INDEX_COLUMN like ", value, "INDEX_COLUMN", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnNotRightLike(String value) {
            addCriterion("INDEX_COLUMN  not like ", value, "INDEX_COLUMN", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnIn(List<String> values) {
            addCriterion("INDEX_COLUMN  in ", values, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnNotIn(List<String> values) {
            addCriterion("INDEX_COLUMN not in ", values, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnBetween(String value1, String value2) {
            addCriterion("INDEX_COLUMN between ", value1, value2, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andIndexColumnNotBetween(String value1, String value2) {
            addCriterion("INDEX_COLUMN not between ", value1, value2, "INDEX_COLUMN");
            return (DmIndexInfoCriteria) this;
        }
        public DmIndexInfoCriteria andStateIsNull() {
            addCriterion("STATE is null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "STATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "STATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "STATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "STATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "STATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "STATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateLike(String value) {
            addCriterion("STATE like ", value, "STATE", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateNotLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateLeftLike(String value) {
            addCriterion("STATE like ", value, "STATE", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateNotLeftLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateRightLike(String value) {
            addCriterion("STATE like ", value, "STATE", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateNotRightLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateIn(List<String> values) {
            addCriterion("STATE  in ", values, "STATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in ", values, "STATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between ", value1, value2, "STATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between ", value1, value2, "STATE");
            return (DmIndexInfoCriteria) this;
        }
        public DmIndexInfoCriteria andStateDateIsNull() {
            addCriterion("STATE_DATE is null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateIsNotNull() {
            addCriterion("STATE_DATE is not null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateEqualTo(String value) {
            addCriterion("STATE_DATE =", value, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateNotEqualTo(String value) {
            addCriterion("STATE_DATE <>", value, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateGreaterThan(String value) {
            addCriterion("STATE_DATE >", value, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE_DATE >=", value, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateLessThan(String value) {
            addCriterion("STATE_DATE <", value, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateLessThanOrEqualTo(String value) {
            addCriterion("STATE_DATE <=", value, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateNotLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateLeftLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateNotLeftLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateRightLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateNotRightLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateIn(List<String> values) {
            addCriterion("STATE_DATE  in ", values, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateNotIn(List<String> values) {
            addCriterion("STATE_DATE not in ", values, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateBetween(String value1, String value2) {
            addCriterion("STATE_DATE between ", value1, value2, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andStateDateNotBetween(String value1, String value2) {
            addCriterion("STATE_DATE not between ", value1, value2, "STATE_DATE");
            return (DmIndexInfoCriteria) this;
        }
        public DmIndexInfoCriteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateEqualTo(String value) {
            addCriterion("CREATE_DATE =", value, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateNotEqualTo(String value) {
            addCriterion("CREATE_DATE <>", value, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateGreaterThan(String value) {
            addCriterion("CREATE_DATE >", value, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE >=", value, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateLessThan(String value) {
            addCriterion("CREATE_DATE <", value, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateLessThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE <=", value, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateNotLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 1);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateLeftLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateNotLeftLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 0);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateRightLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateNotRightLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 2);
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateIn(List<String> values) {
            addCriterion("CREATE_DATE  in ", values, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateNotIn(List<String> values) {
            addCriterion("CREATE_DATE not in ", values, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateBetween(String value1, String value2) {
            addCriterion("CREATE_DATE between ", value1, value2, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

        public DmIndexInfoCriteria andCreateDateNotBetween(String value1, String value2) {
            addCriterion("CREATE_DATE not between ", value1, value2, "CREATE_DATE");
            return (DmIndexInfoCriteria) this;
        }

    }

    public static class DmIndexInfoCriteria extends GeneratedCriteria {

        protected DmIndexInfoCriteria() {
            super();
        }
    }

    public static class DmIndexInfoCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected DmIndexInfoCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected DmIndexInfoCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected DmIndexInfoCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected DmIndexInfoCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected DmIndexInfoCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected DmIndexInfoCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}